{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Incentive Calculator","County-Region Database","Worksheet Variables"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":4,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Incentive Calculator","index":0,"n_rows":74,"n_cols":27,"rows_kept":74,"cut":false,"hidden":false,"merged":[[0,1,3,2],[18,19,21,23],[22,19,25,23],[26,19,30,23],[31,19,34,23],[7,7,7,9],[8,7,8,9],[9,7,9,9],[12,2,12,8],[12,1,13,1],[5,2,5,4],[6,2,6,4],[7,2,7,4],[8,2,8,4],[9,2,9,4],[14,1,17,1],[14,2,17,2],[14,3,17,3],[14,4,17,4],[14,5,17,5],[14,6,17,6],[5,7,5,9],[6,7,6,9],[18,4,21,4],[18,6,21,6],[12,25,12,26],[14,12,17,12],[14,13,17,13],[14,15,17,15],[14,16,17,16],[12,15,12,17],[14,17,17,17],[14,19,17,19],[14,20,17,20],[14,21,17,21],[14,23,17,23],[14,14,17,14],[14,25,17,25],[14,26,17,26],[12,9,12,14],[14,22,17,22],[14,7,17,7],[14,8,17,8],[18,25,21,25],[18,26,21,26],[22,1,25,1],[22,2,25,2],[22,3,25,3],[22,4,25,4],[22,5,25,5],[22,6,25,6],[22,7,25,7],[22,8,25,8],[18,17,21,17],[18,14,21,14],[18,7,21,7],[18,8,21,8],[18,12,21,12],[18,13,21,13],[18,15,21,15],[18,16,21,16],[18,1,21,1],[18,2,21,2],[18,3,21,3],[18,5,21,5],[30,1,33,1],[30,2,33,2],[30,3,33,3],[30,4,33,4],[30,5,33,5],[30,6,33,6],[30,7,33,7],[30,8,33,8],[26,17,29,17],[26,14,29,14],[26,7,29,7],[26,8,29,8],[26,12,29,12],[26,13,29,13],[26,15,29,15],[26,16,29,16],[26,1,29,1],[26,2,29,2],[26,3,29,3],[26,4,29,4],[26,5,29,5],[26,6,29,6],[30,12,33,12],[30,13,33,13],[38,1,41,1],[38,2,41,2],[38,3,41,3],[38,4,41,4],[38,5,41,5],[38,6,41,6],[38,7,41,7],[38,8,41,8],[34,17,37,17],[34,14,37,14],[34,7,37,7],[34,8,37,8],[34,12,37,12],[34,13,37,13],[34,15,37,15],[34,16,37,16],[34,1,37,1],[34,2,37,2],[34,3,37,3],[34,4,37,4],[34,5,37,5],[34,6,37,6],[38,14,41,14],[46,1,49,1],[46,2,49,2],[46,3,49,3],[46,4,49,4],[46,5,49,5],[46,6,49,6],[46,7,49,7],[46,8,49,8],[42,17,45,17],[42,14,45,14],[42,7,45,7],[42,8,45,8],[42,12,45,12],[42,13,45,13],[42,15,45,15],[42,16,45,16],[42,1,45,1],[42,2,45,2],[42,3,45,3],[42,4,45,4],[42,5,45,5],[42,6,45,6],[46,14,49,14],[38,26,41,26],[38,12,41,12],[38,13,41,13],[38,15,41,15],[38,16,41,16],[38,17,41,17],[34,25,37,25],[34,26,37,26],[46,25,49,25],[46,26,49,26],[46,12,49,12],[46,13,49,13],[46,15,49,15],[46,16,49,16],[46,17,49,17],[42,25,45,25],[42,26,45,26],[26,26,29,26],[22,14,25,14],[22,25,25,25],[22,26,25,26],[22,12,25,12],[22,13,25,13],[22,15,25,15],[22,16,25,16],[30,26,33,26],[22,17,25,17],[50,2,53,2],[50,3,53,3],[50,4,53,4],[50,5,53,5],[50,6,53,6],[50,7,53,7],[50,8,53,8],[50,12,53,12],[30,14,33,14],[50,13,53,13],[50,14,53,14],[58,1,61,1],[58,2,61,2],[50,15,53,15],[50,16,53,16],[50,17,53,17],[50,25,53,25],[50,26,53,26],[54,1,57,1],[54,2,57,2],[54,3,57,3],[54,4,57,4],[54,5,57,5],[54,6,57,6],[54,7,57,7],[54,8,57,8],[54,12,57,12],[54,13,57,13],[54,14,57,14],[54,15,57,15],[54,16,57,16],[54,17,57,17],[54,25,57,25],[54,26,57,26],[50,1,53,1],[62,1,65,1],[62,2,65,2],[62,3,65,3],[62,4,65,4],[62,5,65,5],[62,6,65,6],[62,7,65,7],[62,8,65,8],[62,12,65,12],[58,3,61,3],[58,4,61,4],[58,5,61,5],[58,6,61,6],[58,7,61,7],[58,8,61,8],[58,12,61,12],[66,13,69,13],[62,13,65,13],[70,26,73,26],[66,1,69,1],[66,2,69,2],[66,3,69,3],[66,4,69,4],[66,5,69,5],[66,6,69,6],[66,7,69,7],[66,8,69,8],[66,12,69,12],[70,1,73,1],[70,2,73,2],[70,3,73,3],[70,4,73,4],[70,5,73,5],[70,6,73,6],[70,7,73,7],[70,8,73,8],[70,12,73,12],[6,16,6,18],[6,19,6,20],[6,21,6,22],[66,14,69,14],[66,15,69,15],[66,16,69,16],[66,17,69,17],[66,25,69,25],[30,25,33,25],[12,18,12,23],[70,13,73,13],[70,14,73,14],[70,15,73,15],[70,16,73,16],[70,17,73,17],[70,25,73,25],[58,13,61,13],[30,15,33,15],[30,16,33,16],[30,17,33,17],[26,25,29,25],[38,25,41,25],[66,26,69,26],[58,14,61,14],[58,15,61,15],[58,16,61,16],[58,17,61,17],[58,25,61,25],[58,26,61,26],[62,14,65,14],[62,15,65,15],[62,16,65,16],[62,17,65,17],[62,25,65,25],[62,26,65,26]]}
[null,{"$error":"#VALUE!"}]
[null,null,null,"Wisconsin Department of Transportation "]
[null,null,null,{"$f":"_xlfn.CONCAT(\"Department Acceptance Incentive Calculator (Version: \",'Worksheet Variables'!$C$2,\")\")","v":"Department Acceptance Incentive Calculator (Version: 1.0)"}]
[]
[]
[null,"ITEM:",{"$f":"IF($X$15>0,\"INCENTIVE DENSITY HMA PAVEMENT\",\"DISINCENTIVE DENSITY HMA PAVEMENT\")","v":"INCENTIVE DENSITY HMA PAVEMENT"},null,null,null,"PROJECT ID:",null,null,null,null,null,null,"DATE PLACED:"]
[null,"ITEM #:",{"$f":"IF($X$15>0,\"460.2000\",\"804.2005\")","v":"460.2000"},null,null,null,"ROADWAY:",null,null,null,null,null,null,"LOT:",null,null,"Incentive",null,null,"Disincentive",null,"TOTAL"]
[null,"CATEGORY:",null,null,null,null,"DESCRIPTION:",null,null,null,null,null,null,"MAINLINE / SHOULDER / OTHER:",null,null,"Tonnage","Pay Adjustment",null,"Tonnage","Pay Adjustment","Tonnage","Pay Adjustment"]
[null,"ENTERED BY:",null,null,null,null,"COUNTY:",null,null,null,null,null,null,"MINIMUM REQ'D DENSITY:",null,null,{"$f":"IF($U$15>='Worksheet Variables'!$B$9,_xlfn.AGGREGATE(9,6,Z15:Z74),0)","v":0},{"$f":"IF($T$15=\"\",0,IF($X$15>=0,$X$15,0))","v":0},null,{"$f":"_xlfn.AGGREGATE(9,6,AA15:AA74)+IF($U$15<'Worksheet Variables'!$B$9,_xlfn.AGGREGATE(9,6,Z15:Z74),0)","v":0},{"$f":"SUM(R15:R74)+IF($X$15<0,$X$15,0)","v":0},{"$f":"SUM(I15:I74)","v":0},{"$f":"SUM($R$9,$U$9)","v":0}]
[null,"CHECKED BY:",null,null,null,null,"CONTRACT UNIT PRICE:",null,null,null,null,null,null,"PWL DEPARTMENT ACCEPTANCE?:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"ALL QC & QV AIR VOIDS ACCEPTABLE?:"]
[]
[null,"DATE \nPLACED","SUBLOT INFORMATION",null,null,null,null,null,null,"TEST INFORMATION",null,null,null,null,null,"SUBLOT DISINCENTIVES",null,null,"LOT PAY ADJUSTMENT",null,null,null,null,null,null,"Tonnage"]
[null,null,"ID","START\nSTATION","END\nSTATION","LENGTH\n(FT.)","WIDTH\n(FT.)","THICKNESS\n(IN.)","Sublot Tons","TEST\nID","PERCENT DENSITY","ROUNDED INDIVIDUAL DENSITIES","SUBLOT AVERAGE DENSITY (%)","Removed & Replaced?","REMARKS","PERCENT BELOW MIN.","PAY FACTOR\n(%)","DISINCENTIVE","CONTRIBUTING VALUES","LOT AVERAGE","PERCENT LOT DENSITY ABOVE MIN.","PAY ADJUSTMENT / TON","PAY FACTOR","LOT PAY ADJUSTMENT",null,"Incentive","Disincentive"]
[null,{"$f":"IF(ISBLANK(C15),\"\",$O$6)","v":""},null,null,null,{"$f":"IF(OR(D15=\"\",E15=\"\"),\"\",ABS(E15-D15))","v":""},null,null,{"$f":"IF(OR(F15=\"\",ISBLANK(G15),ISBLANK(H15)),\"\",ROUND((F15*G15*H15*'Worksheet Variables'!$C$4)/(9*2000),0))","v":""},null,null,{"$f":"IF(ISBLANK(K15),NA(),ROUND(K15,1))","v":{"$error":"#N/A"}},{"$f":"IFERROR(ROUND(_xlfn.AGGREGATE(1,6,L15:L18),1),\"\")","v":""},null,null,{"$f":"IF(OR(M15=\"\",$O$9=\"\",N15=\"YES\"),\"\",IF(ROUND(M15-$O$9,1)>=-1,\"\",ROUND(ABS(M15-$O$9),1)))","v":""},{"$f":"IF(OR(P15=\"\",$O$9=\"\"),\"\",IF(P15>'Worksheet Variables'!$F$14,'Worksheet Variables'!$H$14,IF(P15>='Worksheet Variables'!$F$13,'Worksheet Variables'!$H$13,IF(P15>='Worksheet Variables'!$F$12,'Worksheet Variables'!$H$12,IF(P15>='Worksheet Variables'!$F$11,'Worksheet Variables'!$H$11,IF(P15>='Worksheet Variables'!$F$10,'Worksheet Variables'!$H$10,IF(P15>='Worksheet Variables'!$F$9,'Worksheet Variables'!$H$9,\"\")))))))","v":""},{"$f":"IF(P15=\"\",\"\",-I15*((100-Q15)/100)*$H$10)","v":""},{"$f":"IFERROR(IF(AND(ROUND(M15-$O$9,1)>=-1,N15=\"NO\"),L15,NA()),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(_xlfn.AGGREGATE(1,6,S15:S74),\"\")","v":""},{"$f":"IFERROR(ROUND($T$15-$O$9,1),\"\")","v":""},{"$f":"IF(U15=\"\",\"\",IF(-U15>='Worksheet Variables'!$F$9,\"N/A\",IF(U15>'Worksheet Variables'!$B$11,'Worksheet Variables'!$D$11,IF(U15>='Worksheet Variables'!$B$10,'Worksheet Variables'!$D$10,IF(U15>='Worksheet Variables'!$B$9,'Worksheet Variables'!$D$9,IF(U15<=-'Worksheet Variables'!$F$14,'Worksheet Variables'!$H$14,\"\"))))))","v":""},{"$f":"IF(U15=\"\",\"\",IF(U15>='Worksheet Variables'!$B$9,\"N/A\",IF(-U15>='Worksheet Variables'!$F$14,'Worksheet Variables'!$H$14,IF(-U15>='Worksheet Variables'!$F$13,'Worksheet Variables'!$H$13,IF(-U15>='Worksheet Variables'!$F$12,'Worksheet Variables'!$H$12,IF(-U15>='Worksheet Variables'!$F$11,'Worksheet Variables'!$H$11,IF(-U15>='Worksheet Variables'!$F$10,'Worksheet Variables'!$H$10,IF(-U15>='Worksheet Variables'!$F$9,'Worksheet Variables'!$H$9,\"\"))))))))","v":""},{"$f":"IF(OR($H$10=\"\",$O$11=\"\",$U$15=\"\"),\"\",IF(AND(OR($O$10=\"YES\",$O$11=\"NO\"),$U$15>='Worksheet Variables'!$B$9),\"Not Elligible\",IF($U$15>='Worksheet Variables'!$B$9,$V$15*$Q$9,-((100-$W$15)/100)*$H$10*$T$9)))","v":""},null,{"$f":"IF(OR(I15=\"\",M15=\"\",$O$9=\"\"),\"\",IF(ROUND(M15-$O$9,1)>=-1,I15,0))","v":""},{"$f":"IF(OR(I15=\"\",M15=\"\",$O$9=\"\"),\"\",IF(ROUND(M15-$O$9,1)<-1,I15,0))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(K16),NA(),ROUND(K16,1))","v":{"$error":"#N/A"}},null,null,null,null,null,null,{"$f":"IFERROR(IF(AND(ROUND(M15-$O$9,1)>=-1,N15=\"NO\"),L16,NA()),NA())","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(K17),NA(),ROUND(K17,1))","v":{"$error":"#N/A"}},null,null,null,null,null,null,{"$f":"IFERROR(IF(AND(ROUND(M15-$O$9,1)>=-1,N15=\"NO\"),L17,NA()),NA())","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(K18),NA(),ROUND(K18,1))","v":{"$error":"#N/A"}},null,null,null,null,null,null,{"$f":"IFERROR(IF(AND(ROUND(M15-$O$9,1)>=-1,N15=\"NO\"),L18,NA()),NA())","v":{"$error":"#N/A"}}]
[null,{"$f":"IF(ISBLANK(C19),\"\",$O$6)","v":""},null,null,null,{"$f":"IF(OR(D19=\"\",E19=\"\"),\"\",ABS(E19-D19))","v":""},null,null,{"$f":"IF(OR(F19=\"\",ISBLANK(G19),ISBLANK(H19)),\"\",ROUND((F19*G19*H19*'Worksheet Variables'!$C$4)/(9*2000),0))","v":""},null,null,{"$f":"IF(ISBLANK(K19),NA(),ROUND(K19,1))","v":{"$error":"#N/A"}},{"$f":"IFERROR(ROUND(_xlfn.AGGREGATE(1,6,L19:L22),1),\"\")","v":""},null,null,{"$f":"IF(OR(M19=\"\",$O$9=\"\",N19=\"YES\"),\"\",IF(ROUND(M19-$O$9,1)>=-1,\"\",ROUND(ABS(M19-$O$9),1)))","v":""},{"$f":"IF(OR(P19=\"\",$O$9=\"\"),\"\",IF(P19>'Worksheet Variables'!$F$14,'Worksheet Variables'!$H$14,IF(P19>='Worksheet Variables'!$F$13,'Worksheet Variables'!$H$13,IF(P19>='Worksheet Variables'!$F$12,'Worksheet Variables'!$H$12,IF(P19>='Worksheet Variables'!$F$11,'Worksheet Variables'!$H$11,IF(P19>='Worksheet Variables'!$F$10,'Worksheet Variables'!$H$10,IF(P19>='Worksheet Variables'!$F$9,'Worksheet Variables'!$H$9,\"\")))))))","v":""},{"$f":"IF(P19=\"\",\"\",-I19*((100-Q19)/100)*$H$10)","v":""},{"$f":"IFERROR(IF(AND(ROUND(M19-$O$9,1)>=-1,N19=\"NO\"),L19,NA()),NA())","v":{"$error":"#N/A"}},"Note 1: According to CMM 815.15.1 and 815.15.2, if a sublot average density is more than 1.0 percent below the required minimum, the sublot does not contribute to the lot average calculation and the sublot is subject to disincentive.",null,null,null,null,null,{"$f":"IF(OR(I19=\"\",M19=\"\",$O$9=\"\"),\"\",IF(ROUND(M19-$O$9,1)>=-1,I19,0))","v":""},{"$f":"IF(OR(I19=\"\",M19=\"\",$O$9=\"\"),\"\",IF(ROUND(M19-$O$9,1)<-1,I19,0))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(K20),NA(),ROUND(K20,1))","v":{"$error":"#N/A"}},null,null,null,null,null,null,{"$f":"IFERROR(IF(AND(ROUND(M19-$O$9,1)>=-1,N19=\"NO\"),L20,NA()),NA())","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},null,null,null,null,null,null,{"$f":"IFERROR(IF(AND(ROUND(M19-$O$9,1)>=-1,N19=\"NO\"),L21,NA()),NA())","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},null,null,null,null,null,null,{"$f":"IFERROR(IF(AND(ROUND(M19-$O$9,1)>=-1,N19=\"NO\"),L22,NA()),NA())","v":{"$error":"#N/A"}}]
[null,{"$f":"IF(ISBLANK(C23),\"\",$O$6)","v":""},null,null,null,{"$f":"IF(OR(D23=\"\",E23=\"\"),\"\",ABS(E23-D23))","v":""},null,null,{"$f":"IF(OR(F23=\"\",ISBLANK(G23),ISBLANK(H23)),\"\",ROUND((F23*G23*H23*'Worksheet Variables'!$C$4)/(9*2000),0))","v":""},null,null,{"$f":"IF(ISBLANK(K23),NA(),ROUND(K23,1))","v":{"$error":"#N/A"}},{"$f":"IFERROR(ROUND(_xlfn.AGGREGATE(1,6,L23:L26),1),\"\")","v":""},null,null,{"$f":"IF(OR(M23=\"\",$O$9=\"\",N23=\"YES\"),\"\",IF(ROUND(M23-$O$9,1)>=-1,\"\",ROUND(ABS(M23-$O$9),1)))","v":""},{"$f":"IF(OR(P23=\"\",$O$9=\"\"),\"\",IF(P23>'Worksheet Variables'!$F$14,'Worksheet Variables'!$H$14,IF(P23>='Worksheet Variables'!$F$13,'Worksheet Variables'!$H$13,IF(P23>='Worksheet Variables'!$F$12,'Worksheet Variables'!$H$12,IF(P23>='Worksheet Variables'!$F$11,'Worksheet Variables'!$H$11,IF(P23>='Worksheet Variables'!$F$10,'Worksheet Variables'!$H$10,IF(P23>='Worksheet Variables'!$F$9,'Worksheet Variables'!$H$9,\"\")))))))","v":""},{"$f":"IF(P23=\"\",\"\",-I23*((100-Q23)/100)*$H$10)","v":""},{"$f":"IFERROR(IF(AND(ROUND(M23-$O$9,1)>=-1,N23=\"NO\"),L23,NA()),NA())","v":{"$error":"#N/A"}},"Note 2: All QC and QV individual air voids test results for the mixture placed during the same day must be within 2.5 - 4.0% for HMA and 4.0 - 5.5% for SMA to be elligible for density incentive according to Standard Spec 460.5.2.3(1).",null,null,null,null,null,{"$f":"IF(OR(I23=\"\",M23=\"\",$O$9=\"\"),\"\",IF(ROUND(M23-$O$9,1)>=-1,I23,0))","v":""},{"$f":"IF(OR(I23=\"\",M23=\"\",$O$9=\"\"),\"\",IF(ROUND(M23-$O$9,1)<-1,I23,0))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},null,null,null,null,null,null,{"$f":"IFERROR(IF(AND(ROUND(M23-$O$9,1)>=-1,N23=\"NO\"),L24,NA()),NA())","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},null,null,null,null,null,null,{"$f":"IFERROR(IF(AND(ROUND(M23-$O$9,1)>=-1,N23=\"NO\"),L25,NA()),NA())","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},null,null,null,null,null,null,{"$f":"IFERROR(IF(AND(ROUND(M23-$O$9,1)>=-1,N23=\"NO\"),L26,NA()),NA())","v":{"$error":"#N/A"}}]
[null,{"$f":"IF(ISBLANK(C27),\"\",$O$6)","v":""},null,null,null,{"$f":"IF(OR(D27=\"\",E27=\"\"),\"\",ABS(E27-D27))","v":""},null,null,{"$f":"IF(OR(F27=\"\",ISBLANK(G27),ISBLANK(H27)),\"\",ROUND((F27*G27*H27*'Worksheet Variables'!$C$4)/(9*2000),0))","v":""},null,null,{"$f":"IF(ISBLANK(K27),NA(),ROUND(K27,1))","v":{"$error":"#N/A"}},{"$f":"IFERROR(ROUND(_xlfn.AGGREGATE(1,6,L27:L30),1),\"\")","v":""},null,null,{"$f":"IF(OR(M27=\"\",$O$9=\"\",N27=\"YES\"),\"\",IF(ROUND(M27-$O$9,1)>=-1,\"\",ROUND(ABS(M27-$O$9),1)))","v":""},{"$f":"IF(OR(P27=\"\",$O$9=\"\"),\"\",IF(P27>'Worksheet Variables'!$F$14,'Worksheet Variables'!$H$14,IF(P27>='Worksheet Variables'!$F$13,'Worksheet Variables'!$H$13,IF(P27>='Worksheet Variables'!$F$12,'Worksheet Variables'!$H$12,IF(P27>='Worksheet Variables'!$F$11,'Worksheet Variables'!$H$11,IF(P27>='Worksheet Variables'!$F$10,'Worksheet Variables'!$H$10,IF(P27>='Worksheet Variables'!$F$9,'Worksheet Variables'!$H$9,\"\")))))))","v":""},{"$f":"IF(P27=\"\",\"\",-I27*((100-Q27)/100)*$H$10)","v":""},{"$f":"IFERROR(IF(AND(ROUND(M27-$O$9,1)>=-1,N27=\"NO\"),L27,NA()),NA())","v":{"$error":"#N/A"}},"Note 3: According to Standard Spec 460.5.2.2(1), sublots with average densities more than 3.0 percent below the minimum required density are subject to be removed and replaced at the discretion of the engineer. If allowed to remain in place, the material will be paid at 50% of the contract unit price. ",null,null,null,null,null,{"$f":"IF(OR(I27=\"\",M27=\"\",$O$9=\"\"),\"\",IF(ROUND(M27-$O$9,1)>=-1,I27,0))","v":""},{"$f":"IF(OR(I27=\"\",M27=\"\",$O$9=\"\"),\"\",IF(ROUND(M27-$O$9,1)<-1,I27,0))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},null,null,null,null,null,null,{"$f":"IFERROR(IF(AND(ROUND(M27-$O$9,1)>=-1,N27=\"NO\"),L28,NA()),NA())","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},null,null,null,null,null,null,{"$f":"IFERROR(IF(AND(ROUND(M27-$O$9,1)>=-1,N27=\"NO\"),L29,NA()),NA())","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},null,null,null,null,null,null,{"$f":"IFERROR(IF(AND(ROUND(M27-$O$9,1)>=-1,N27=\"NO\"),L30,NA()),NA())","v":{"$error":"#N/A"}}]
[null,{"$f":"IF(ISBLANK(C31),\"\",$O$6)","v":""},null,null,null,{"$f":"IF(OR(D31=\"\",E31=\"\"),\"\",ABS(E31-D31))","v":""},null,null,{"$f":"IF(OR(F31=\"\",ISBLANK(G31),ISBLANK(H31)),\"\",ROUND((F31*G31*H31*'Worksheet Variables'!$C$4)/(9*2000),0))","v":""},null,null,{"$error":"#N/A"},{"$f":"IFERROR(ROUND(_xlfn.AGGREGATE(1,6,L31:L34),1),\"\")","v":""},null,null,{"$f":"IF(OR(M31=\"\",$O$9=\"\",N31=\"YES\"),\"\",IF(ROUND(M31-$O$9,1)>=-1,\"\",ROUND(ABS(M31-$O$9),1)))","v":""},{"$f":"IF(OR(P31=\"\",$O$9=\"\"),\"\",IF(P31>'Worksheet Variables'!$F$14,'Worksheet Variables'!$H$14,IF(P31>='Worksheet Variables'!$F$13,'Worksheet Variables'!$H$13,IF(P31>='Worksheet Variables'!$F$12,'Worksheet Variables'!$H$12,IF(P31>='Worksheet Variables'!$F$11,'Worksheet Variables'!$H$11,IF(P31>='Worksheet Variables'!$F$10,'Worksheet Variables'!$H$10,IF(P31>='Worksheet Variables'!$F$9,'Worksheet Variables'!$H$9,\"\")))))))","v":""},{"$f":"IF(P31=\"\",\"\",-I31*((100-Q31)/100)*$H$10)","v":""},{"$f":"IFERROR(IF(AND(ROUND(M31-$O$9,1)>=-1,N31=\"NO\"),L31,NA()),NA())","v":{"$error":"#N/A"}},null,null,null,null,null,null,{"$f":"IF(OR(I31=\"\",M31=\"\",$O$9=\"\"),\"\",IF(ROUND(M31-$O$9,1)>=-1,I31,0))","v":""},{"$f":"IF(OR(I31=\"\",M31=\"\",$O$9=\"\"),\"\",IF(ROUND(M31-$O$9,1)<-1,I31,0))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},null,null,null,null,null,null,{"$f":"IFERROR(IF(AND(ROUND(M31-$O$9,1)>=-1,N31=\"NO\"),L32,NA()),NA())","v":{"$error":"#N/A"}},"Note 4: For shoulders paved integrally with the traffic lane, if the traffic lane does not meet incentive requirements, the department will not pay for incentive on the integrally paved shoulder according to Standard Spec 460.5.2.3(3)."]
[null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},null,null,null,null,null,null,{"$f":"IFERROR(IF(AND(ROUND(M31-$O$9,1)>=-1,N31=\"NO\"),L33,NA()),NA())","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},null,null,null,null,null,null,{"$f":"IFERROR(IF(AND(ROUND(M31-$O$9,1)>=-1,N31=\"NO\"),L34,NA()),NA())","v":{"$error":"#N/A"}}]
[null,{"$f":"IF(ISBLANK(C35),\"\",$O$6)","v":""},null,null,null,{"$f":"IF(OR(D35=\"\",E35=\"\"),\"\",ABS(E35-D35))","v":""},null,null,{"$f":"IF(OR(F35=\"\",ISBLANK(G35),ISBLANK(H35)),\"\",ROUND((F35*G35*H35*'Worksheet Variables'!$C$4)/(9*2000),0))","v":""},null,null,{"$error":"#N/A"},{"$f":"IFERROR(ROUND(_xlfn.AGGREGATE(1,6,L35:L38),1),\"\")","v":""},null,null,{"$f":"IF(OR(M35=\"\",$O$9=\"\",N35=\"YES\"),\"\",IF(ROUND(M35-$O$9,1)>=-1,\"\",ROUND(ABS(M35-$O$9),1)))","v":""},{"$f":"IF(OR(P35=\"\",$O$9=\"\"),\"\",IF(P35>'Worksheet Variables'!$F$14,'Worksheet Variables'!$H$14,IF(P35>='Worksheet Variables'!$F$13,'Worksheet Variables'!$H$13,IF(P35>='Worksheet Variables'!$F$12,'Worksheet Variables'!$H$12,IF(P35>='Worksheet Variables'!$F$11,'Worksheet Variables'!$H$11,IF(P35>='Worksheet Variables'!$F$10,'Worksheet Variables'!$H$10,IF(P35>='Worksheet Variables'!$F$9,'Worksheet Variables'!$H$9,\"\")))))))","v":""},{"$f":"IF(P35=\"\",\"\",-I35*((100-Q35)/100)*$H$10)","v":""},{"$f":"IFERROR(IF(AND(ROUND(M35-$O$9,1)>=-1,N35=\"NO\"),L35,NA()),NA())","v":{"$error":"#N/A"}},null,null,null,null,null,null,{"$f":"IF(OR(I35=\"\",M35=\"\",$O$9=\"\"),\"\",IF(ROUND(M35-$O$9,1)>=-1,I35,0))","v":""},{"$f":"IF(OR(I35=\"\",M35=\"\",$O$9=\"\"),\"\",IF(ROUND(M35-$O$9,1)<-1,I35,0))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},null,null,null,null,null,null,{"$f":"IFERROR(IF(AND(ROUND(M35-$O$9,1)>=-1,N35=\"NO\"),L36,NA()),NA())","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},null,null,null,null,null,null,{"$f":"IFERROR(IF(AND(ROUND(M35-$O$9,1)>=-1,N35=\"NO\"),L37,NA()),NA())","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},null,null,null,null,null,null,{"$f":"IFERROR(IF(AND(ROUND(M35-$O$9,1)>=-1,N35=\"NO\"),L38,NA()),NA())","v":{"$error":"#N/A"}}]
[null,{"$f":"IF(ISBLANK(C39),\"\",$O$6)","v":""},null,null,null,{"$f":"IF(OR(D39=\"\",E39=\"\"),\"\",ABS(E39-D39))","v":""},null,null,{"$f":"IF(OR(F39=\"\",ISBLANK(G39),ISBLANK(H39)),\"\",ROUND((F39*G39*H39*'Worksheet Variables'!$C$4)/(9*2000),0))","v":""},null,null,{"$error":"#N/A"},{"$f":"IFERROR(ROUND(_xlfn.AGGREGATE(1,6,L39:L42),1),\"\")","v":""},null,null,{"$f":"IF(OR(M39=\"\",$O$9=\"\",N39=\"YES\"),\"\",IF(ROUND(M39-$O$9,1)>=-1,\"\",ROUND(ABS(M39-$O$9),1)))","v":""},{"$f":"IF(OR(P39=\"\",$O$9=\"\"),\"\",IF(P39>'Worksheet Variables'!$F$14,'Worksheet Variables'!$H$14,IF(P39>='Worksheet Variables'!$F$13,'Worksheet Variables'!$H$13,IF(P39>='Worksheet Variables'!$F$12,'Worksheet Variables'!$H$12,IF(P39>='Worksheet Variables'!$F$11,'Worksheet Variables'!$H$11,IF(P39>='Worksheet Variables'!$F$10,'Worksheet Variables'!$H$10,IF(P39>='Worksheet Variables'!$F$9,'Worksheet Variables'!$H$9,\"\")))))))","v":""},{"$f":"IF(P39=\"\",\"\",-I39*((100-Q39)/100)*$H$10)","v":""},{"$f":"IFERROR(IF(AND(ROUND(M39-$O$9,1)>=-1,N39=\"NO\"),L39,NA()),NA())","v":{"$error":"#N/A"}},null,null,null,null,null,null,{"$f":"IF(OR(I39=\"\",M39=\"\",$O$9=\"\"),\"\",IF(ROUND(M39-$O$9,1)>=-1,I39,0))","v":""},{"$f":"IF(OR(I39=\"\",M39=\"\",$O$9=\"\"),\"\",IF(ROUND(M39-$O$9,1)<-1,I39,0))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},null,null,null,null,null,null,{"$f":"IFERROR(IF(AND(ROUND(M39-$O$9,1)>=-1,N39=\"NO\"),L40,NA()),NA())","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},null,null,null,null,null,null,{"$f":"IFERROR(IF(AND(ROUND(M39-$O$9,1)>=-1,N39=\"NO\"),L41,NA()),NA())","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},null,null,null,null,null,null,{"$f":"IFERROR(IF(AND(ROUND(M39-$O$9,1)>=-1,N39=\"NO\"),L42,NA()),NA())","v":{"$error":"#N/A"}}]
[null,{"$f":"IF(ISBLANK(C43),\"\",$O$6)","v":""},null,null,null,{"$f":"IF(OR(D43=\"\",E43=\"\"),\"\",ABS(E43-D43))","v":""},null,null,{"$f":"IF(OR(F43=\"\",ISBLANK(G43),ISBLANK(H43)),\"\",ROUND((F43*G43*H43*'Worksheet Variables'!$C$4)/(9*2000),0))","v":""},null,null,{"$error":"#N/A"},{"$f":"IFERROR(ROUND(_xlfn.AGGREGATE(1,6,L43:L46),1),\"\")","v":""},null,null,{"$f":"IF(OR(M43=\"\",$O$9=\"\",N43=\"YES\"),\"\",IF(ROUND(M43-$O$9,1)>=-1,\"\",ROUND(ABS(M43-$O$9),1)))","v":""},{"$f":"IF(OR(P43=\"\",$O$9=\"\"),\"\",IF(P43>'Worksheet Variables'!$F$14,'Worksheet Variables'!$H$14,IF(P43>='Worksheet Variables'!$F$13,'Worksheet Variables'!$H$13,IF(P43>='Worksheet Variables'!$F$12,'Worksheet Variables'!$H$12,IF(P43>='Worksheet Variables'!$F$11,'Worksheet Variables'!$H$11,IF(P43>='Worksheet Variables'!$F$10,'Worksheet Variables'!$H$10,IF(P43>='Worksheet Variables'!$F$9,'Worksheet Variables'!$H$9,\"\")))))))","v":""},{"$f":"IF(P43=\"\",\"\",-I43*((100-Q43)/100)*$H$10)","v":""},{"$f":"IFERROR(IF(AND(ROUND(M43-$O$9,1)>=-1,N43=\"NO\"),L43,NA()),NA())","v":{"$error":"#N/A"}},null,null,null,null,null,null,{"$f":"IF(OR(I43=\"\",M43=\"\",$O$9=\"\"),\"\",IF(ROUND(M43-$O$9,1)>=-1,I43,0))","v":""},{"$f":"IF(OR(I43=\"\",M43=\"\",$O$9=\"\"),\"\",IF(ROUND(M43-$O$9,1)<-1,I43,0))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},null,null,null,null,null,null,{"$f":"IFERROR(IF(AND(ROUND(M43-$O$9,1)>=-1,N43=\"NO\"),L44,NA()),NA())","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},null,null,null,null,null,null,{"$f":"IFERROR(IF(AND(ROUND(M43-$O$9,1)>=-1,N43=\"NO\"),L45,NA()),NA())","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},null,null,null,null,null,null,{"$f":"IFERROR(IF(AND(ROUND(M43-$O$9,1)>=-1,N43=\"NO\"),L46,NA()),NA())","v":{"$error":"#N/A"}}]
[null,{"$f":"IF(ISBLANK(C47),\"\",$O$6)","v":""},null,null,null,{"$f":"IF(OR(D47=\"\",E47=\"\"),\"\",ABS(E47-D47))","v":""},null,null,{"$f":"IF(OR(F47=\"\",ISBLANK(G47),ISBLANK(H47)),\"\",ROUND((F47*G47*H47*'Worksheet Variables'!$C$4)/(9*2000),0))","v":""},null,null,{"$error":"#N/A"},{"$f":"IFERROR(ROUND(_xlfn.AGGREGATE(1,6,L47:L50),1),\"\")","v":""},null,null,{"$f":"IF(OR(M47=\"\",$O$9=\"\",N47=\"YES\"),\"\",IF(ROUND(M47-$O$9,1)>=-1,\"\",ROUND(ABS(M47-$O$9),1)))","v":""},{"$f":"IF(OR(P47=\"\",$O$9=\"\"),\"\",IF(P47>'Worksheet Variables'!$F$14,'Worksheet Variables'!$H$14,IF(P47>='Worksheet Variables'!$F$13,'Worksheet Variables'!$H$13,IF(P47>='Worksheet Variables'!$F$12,'Worksheet Variables'!$H$12,IF(P47>='Worksheet Variables'!$F$11,'Worksheet Variables'!$H$11,IF(P47>='Worksheet Variables'!$F$10,'Worksheet Variables'!$H$10,IF(P47>='Worksheet Variables'!$F$9,'Worksheet Variables'!$H$9,\"\")))))))","v":""},{"$f":"IF(P47=\"\",\"\",-I47*((100-Q47)/100)*$H$10)","v":""},{"$f":"IFERROR(IF(AND(ROUND(M47-$O$9,1)>=-1,N47=\"NO\"),L47,NA()),NA())","v":{"$error":"#N/A"}},null,null,null,null,null,null,{"$f":"IF(OR(I47=\"\",M47=\"\",$O$9=\"\"),\"\",IF(ROUND(M47-$O$9,1)>=-1,I47,0))","v":""},{"$f":"IF(OR(I47=\"\",M47=\"\",$O$9=\"\"),\"\",IF(ROUND(M47-$O$9,1)<-1,I47,0))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},null,null,null,null,null,null,{"$f":"IFERROR(IF(AND(ROUND(M47-$O$9,1)>=-1,N47=\"NO\"),L48,NA()),NA())","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},null,null,null,null,null,null,{"$f":"IFERROR(IF(AND(ROUND(M47-$O$9,1)>=-1,N47=\"NO\"),L49,NA()),NA())","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},null,null,null,null,null,null,{"$f":"IFERROR(IF(AND(ROUND(M47-$O$9,1)>=-1,N47=\"NO\"),L50,NA()),NA())","v":{"$error":"#N/A"}}]
[null,{"$f":"IF(ISBLANK(C51),\"\",$O$6)","v":""},null,null,null,{"$f":"IF(OR(D51=\"\",E51=\"\"),\"\",ABS(E51-D51))","v":""},null,null,{"$f":"IF(OR(F51=\"\",ISBLANK(G51),ISBLANK(H51)),\"\",ROUND((F51*G51*H51*'Worksheet Variables'!$C$4)/(9*2000),0))","v":""},null,null,{"$f":"IF(ISBLANK(K51),NA(),ROUND(K51,1))","v":{"$error":"#N/A"}},{"$f":"IFERROR(ROUND(_xlfn.AGGREGATE(1,6,L51:L54),1),\"\")","v":""},null,null,{"$f":"IF(OR(M51=\"\",$O$9=\"\",N51=\"YES\"),\"\",IF(ROUND(M51-$O$9,1)>=-1,\"\",ROUND(ABS(M51-$O$9),1)))","v":""},{"$f":"IF(OR(P51=\"\",$O$9=\"\"),\"\",IF(P51>'Worksheet Variables'!$F$14,'Worksheet Variables'!$H$14,IF(P51>='Worksheet Variables'!$F$13,'Worksheet Variables'!$H$13,IF(P51>='Worksheet Variables'!$F$12,'Worksheet Variables'!$H$12,IF(P51>='Worksheet Variables'!$F$11,'Worksheet Variables'!$H$11,IF(P51>='Worksheet Variables'!$F$10,'Worksheet Variables'!$H$10,IF(P51>='Worksheet Variables'!$F$9,'Worksheet Variables'!$H$9,\"\")))))))","v":""},{"$f":"IF(P51=\"\",\"\",-I51*((100-Q51)/100)*$H$10)","v":""},{"$f":"IFERROR(IF(AND(ROUND(M51-$O$9,1)>=-1,N51=\"NO\"),L51,NA()),NA())","v":{"$error":"#N/A"}},null,null,null,null,null,null,{"$f":"IF(OR(I51=\"\",M51=\"\",$O$9=\"\"),\"\",IF(ROUND(M51-$O$9,1)>=-1,I51,0))","v":""},{"$f":"IF(OR(I51=\"\",M51=\"\",$O$9=\"\"),\"\",IF(ROUND(M51-$O$9,1)<-1,I51,0))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},null,null,null,null,null,null,{"$f":"IFERROR(IF(AND(ROUND(M51-$O$9,1)>=-1,N51=\"NO\"),L52,NA()),NA())","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},null,null,null,null,null,null,{"$f":"IFERROR(IF(AND(ROUND(M51-$O$9,1)>=-1,N51=\"NO\"),L53,NA()),NA())","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},null,null,null,null,null,null,{"$f":"IFERROR(IF(AND(ROUND(M51-$O$9,1)>=-1,N51=\"NO\"),L54,NA()),NA())","v":{"$error":"#N/A"}}]
[null,{"$f":"IF(ISBLANK(C55),\"\",$O$6)","v":""},null,null,null,{"$f":"IF(OR(D55=\"\",E55=\"\"),\"\",ABS(E55-D55))","v":""},null,null,{"$f":"IF(OR(F55=\"\",ISBLANK(G55),ISBLANK(H55)),\"\",ROUND((F55*G55*H55*'Worksheet Variables'!$C$4)/(9*2000),0))","v":""},null,null,{"$error":"#N/A"},{"$f":"IFERROR(ROUND(_xlfn.AGGREGATE(1,6,L55:L58),1),\"\")","v":""},null,null,{"$f":"IF(OR(M55=\"\",$O$9=\"\",N55=\"YES\"),\"\",IF(ROUND(M55-$O$9,1)>=-1,\"\",ROUND(ABS(M55-$O$9),1)))","v":""},{"$f":"IF(OR(P55=\"\",$O$9=\"\"),\"\",IF(P55>'Worksheet Variables'!$F$14,'Worksheet Variables'!$H$14,IF(P55>='Worksheet Variables'!$F$13,'Worksheet Variables'!$H$13,IF(P55>='Worksheet Variables'!$F$12,'Worksheet Variables'!$H$12,IF(P55>='Worksheet Variables'!$F$11,'Worksheet Variables'!$H$11,IF(P55>='Worksheet Variables'!$F$10,'Worksheet Variables'!$H$10,IF(P55>='Worksheet Variables'!$F$9,'Worksheet Variables'!$H$9,\"\")))))))","v":""},{"$f":"IF(P55=\"\",\"\",-I55*((100-Q55)/100)*$H$10)","v":""},{"$f":"IFERROR(IF(AND(ROUND(M55-$O$9,1)>=-1,N55=\"NO\"),L55,NA()),NA())","v":{"$error":"#N/A"}},null,null,null,null,null,null,{"$f":"IF(OR(I55=\"\",M55=\"\",$O$9=\"\"),\"\",IF(ROUND(M55-$O$9,1)>=-1,I55,0))","v":""},{"$f":"IF(OR(I55=\"\",M55=\"\",$O$9=\"\"),\"\",IF(ROUND(M55-$O$9,1)<-1,I55,0))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},null,null,null,null,null,null,{"$f":"IFERROR(IF(AND(ROUND(M55-$O$9,1)>=-1,N55=\"NO\"),L56,NA()),NA())","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},null,null,null,null,null,null,{"$f":"IFERROR(IF(AND(ROUND(M55-$O$9,1)>=-1,N55=\"NO\"),L57,NA()),NA())","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},null,null,null,null,null,null,{"$f":"IFERROR(IF(AND(ROUND(M55-$O$9,1)>=-1,N55=\"NO\"),L58,NA()),NA())","v":{"$error":"#N/A"}}]
[null,{"$f":"IF(ISBLANK(C59),\"\",$O$6)","v":""},null,null,null,{"$f":"IF(OR(D59=\"\",E59=\"\"),\"\",ABS(E59-D59))","v":""},null,null,{"$f":"IF(OR(F59=\"\",ISBLANK(G59),ISBLANK(H59)),\"\",ROUND((F59*G59*H59*'Worksheet Variables'!$C$4)/(9*2000),0))","v":""},null,null,{"$error":"#N/A"},{"$f":"IFERROR(ROUND(_xlfn.AGGREGATE(1,6,L59:L62),1),\"\")","v":""},null,null,{"$f":"IF(OR(M59=\"\",$O$9=\"\",N59=\"YES\"),\"\",IF(ROUND(M59-$O$9,1)>=-1,\"\",ROUND(ABS(M59-$O$9),1)))","v":""},{"$f":"IF(OR(P59=\"\",$O$9=\"\"),\"\",IF(P59>'Worksheet Variables'!$F$14,'Worksheet Variables'!$H$14,IF(P59>='Worksheet Variables'!$F$13,'Worksheet Variables'!$H$13,IF(P59>='Worksheet Variables'!$F$12,'Worksheet Variables'!$H$12,IF(P59>='Worksheet Variables'!$F$11,'Worksheet Variables'!$H$11,IF(P59>='Worksheet Variables'!$F$10,'Worksheet Variables'!$H$10,IF(P59>='Worksheet Variables'!$F$9,'Worksheet Variables'!$H$9,\"\")))))))","v":""},{"$f":"IF(P59=\"\",\"\",-I59*((100-Q59)/100)*$H$10)","v":""},{"$f":"IFERROR(IF(AND(ROUND(M59-$O$9,1)>=-1,N59=\"NO\"),L59,NA()),NA())","v":{"$error":"#N/A"}},null,null,null,null,null,null,{"$f":"IF(OR(I59=\"\",M59=\"\",$O$9=\"\"),\"\",IF(ROUND(M59-$O$9,1)>=-1,I59,0))","v":""},{"$f":"IF(OR(I59=\"\",M59=\"\",$O$9=\"\"),\"\",IF(ROUND(M59-$O$9,1)<-1,I59,0))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},null,null,null,null,null,null,{"$f":"IFERROR(IF(AND(ROUND(M59-$O$9,1)>=-1,N59=\"NO\"),L60,NA()),NA())","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},null,null,null,null,null,null,{"$f":"IFERROR(IF(AND(ROUND(M59-$O$9,1)>=-1,N59=\"NO\"),L61,NA()),NA())","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},null,null,null,null,null,null,{"$f":"IFERROR(IF(AND(ROUND(M59-$O$9,1)>=-1,N59=\"NO\"),L62,NA()),NA())","v":{"$error":"#N/A"}}]
[null,{"$f":"IF(ISBLANK(C63),\"\",$O$6)","v":""},null,null,null,{"$f":"IF(OR(D63=\"\",E63=\"\"),\"\",ABS(E63-D63))","v":""},null,null,{"$f":"IF(OR(F63=\"\",ISBLANK(G63),ISBLANK(H63)),\"\",ROUND((F63*G63*H63*'Worksheet Variables'!$C$4)/(9*2000),0))","v":""},null,null,{"$error":"#N/A"},{"$f":"IFERROR(ROUND(_xlfn.AGGREGATE(1,6,L63:L66),1),\"\")","v":""},null,null,{"$f":"IF(OR(M63=\"\",$O$9=\"\",N63=\"YES\"),\"\",IF(ROUND(M63-$O$9,1)>=-1,\"\",ROUND(ABS(M63-$O$9),1)))","v":""},{"$f":"IF(OR(P63=\"\",$O$9=\"\"),\"\",IF(P63>'Worksheet Variables'!$F$14,'Worksheet Variables'!$H$14,IF(P63>='Worksheet Variables'!$F$13,'Worksheet Variables'!$H$13,IF(P63>='Worksheet Variables'!$F$12,'Worksheet Variables'!$H$12,IF(P63>='Worksheet Variables'!$F$11,'Worksheet Variables'!$H$11,IF(P63>='Worksheet Variables'!$F$10,'Worksheet Variables'!$H$10,IF(P63>='Worksheet Variables'!$F$9,'Worksheet Variables'!$H$9,\"\")))))))","v":""},{"$f":"IF(P63=\"\",\"\",-I63*((100-Q63)/100)*$H$10)","v":""},{"$f":"IFERROR(IF(AND(ROUND(M63-$O$9,1)>=-1,N63=\"NO\"),L63,NA()),NA())","v":{"$error":"#N/A"}},null,null,null,null,null,null,{"$f":"IF(OR(I63=\"\",M63=\"\",$O$9=\"\"),\"\",IF(ROUND(M63-$O$9,1)>=-1,I63,0))","v":""},{"$f":"IF(OR(I63=\"\",M63=\"\",$O$9=\"\"),\"\",IF(ROUND(M63-$O$9,1)<-1,I63,0))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},null,null,null,null,null,null,{"$f":"IFERROR(IF(AND(ROUND(M63-$O$9,1)>=-1,N63=\"NO\"),L64,NA()),NA())","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},null,null,null,null,null,null,{"$f":"IFERROR(IF(AND(ROUND(M63-$O$9,1)>=-1,N63=\"NO\"),L65,NA()),NA())","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},null,null,null,null,null,null,{"$f":"IFERROR(IF(AND(ROUND(M63-$O$9,1)>=-1,N63=\"NO\"),L66,NA()),NA())","v":{"$error":"#N/A"}}]
[null,{"$f":"IF(ISBLANK(C67),\"\",$O$6)","v":""},null,null,null,{"$f":"IF(OR(D67=\"\",E67=\"\"),\"\",ABS(E67-D67))","v":""},null,null,{"$f":"IF(OR(F67=\"\",ISBLANK(G67),ISBLANK(H67)),\"\",ROUND((F67*G67*H67*'Worksheet Variables'!$C$4)/(9*2000),0))","v":""},null,null,{"$error":"#N/A"},{"$f":"IFERROR(ROUND(_xlfn.AGGREGATE(1,6,L67:L70),1),\"\")","v":""},null,null,{"$f":"IF(OR(M67=\"\",$O$9=\"\",N67=\"YES\"),\"\",IF(ROUND(M67-$O$9,1)>=-1,\"\",ROUND(ABS(M67-$O$9),1)))","v":""},{"$f":"IF(OR(P67=\"\",$O$9=\"\"),\"\",IF(P67>'Worksheet Variables'!$F$14,'Worksheet Variables'!$H$14,IF(P67>='Worksheet Variables'!$F$13,'Worksheet Variables'!$H$13,IF(P67>='Worksheet Variables'!$F$12,'Worksheet Variables'!$H$12,IF(P67>='Worksheet Variables'!$F$11,'Worksheet Variables'!$H$11,IF(P67>='Worksheet Variables'!$F$10,'Worksheet Variables'!$H$10,IF(P67>='Worksheet Variables'!$F$9,'Worksheet Variables'!$H$9,\"\")))))))","v":""},{"$f":"IF(P67=\"\",\"\",-I67*((100-Q67)/100)*$H$10)","v":""},{"$f":"IFERROR(IF(AND(ROUND(M67-$O$9,1)>=-1,N67=\"NO\"),L67,NA()),NA())","v":{"$error":"#N/A"}},null,null,null,null,null,null,{"$f":"IF(OR(I67=\"\",M67=\"\",$O$9=\"\"),\"\",IF(ROUND(M67-$O$9,1)>=-1,I67,0))","v":""},{"$f":"IF(OR(I67=\"\",M67=\"\",$O$9=\"\"),\"\",IF(ROUND(M67-$O$9,1)<-1,I67,0))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},null,null,null,null,null,null,{"$f":"IFERROR(IF(AND(ROUND(M67-$O$9,1)>=-1,N67=\"NO\"),L68,NA()),NA())","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},null,null,null,null,null,null,{"$f":"IFERROR(IF(AND(ROUND(M67-$O$9,1)>=-1,N67=\"NO\"),L69,NA()),NA())","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},null,null,null,null,null,null,{"$f":"IFERROR(IF(AND(ROUND(M67-$O$9,1)>=-1,N67=\"NO\"),L70,NA()),NA())","v":{"$error":"#N/A"}}]
[null,{"$f":"IF(ISBLANK(C71),\"\",$O$6)","v":""},null,null,null,{"$f":"IF(OR(D71=\"\",E71=\"\"),\"\",ABS(E71-D71))","v":""},null,null,{"$f":"IF(OR(F71=\"\",ISBLANK(G71),ISBLANK(H71)),\"\",ROUND((F71*G71*H71*'Worksheet Variables'!$C$4)/(9*2000),0))","v":""},null,null,{"$error":"#N/A"},{"$f":"IFERROR(ROUND(_xlfn.AGGREGATE(1,6,L71:L74),1),\"\")","v":""},null,null,{"$f":"IF(OR(M71=\"\",$O$9=\"\",N71=\"YES\"),\"\",IF(ROUND(M71-$O$9,1)>=-1,\"\",ROUND(ABS(M71-$O$9),1)))","v":""},{"$f":"IF(OR(P71=\"\",$O$9=\"\"),\"\",IF(P71>'Worksheet Variables'!$F$14,'Worksheet Variables'!$H$14,IF(P71>='Worksheet Variables'!$F$13,'Worksheet Variables'!$H$13,IF(P71>='Worksheet Variables'!$F$12,'Worksheet Variables'!$H$12,IF(P71>='Worksheet Variables'!$F$11,'Worksheet Variables'!$H$11,IF(P71>='Worksheet Variables'!$F$10,'Worksheet Variables'!$H$10,IF(P71>='Worksheet Variables'!$F$9,'Worksheet Variables'!$H$9,\"\")))))))","v":""},{"$f":"IF(P71=\"\",\"\",-I71*((100-Q71)/100)*$H$10)","v":""},{"$f":"IFERROR(IF(AND(ROUND(M71-$O$9,1)>=-1,N71=\"NO\"),L71,NA()),NA())","v":{"$error":"#N/A"}},null,null,null,null,null,null,{"$f":"IF(OR(I71=\"\",M71=\"\",$O$9=\"\"),\"\",IF(ROUND(M71-$O$9,1)>=-1,I71,0))","v":""},{"$f":"IF(OR(I71=\"\",M71=\"\",$O$9=\"\"),\"\",IF(ROUND(M71-$O$9,1)<-1,I71,0))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},null,null,null,null,null,null,{"$f":"IFERROR(IF(AND(ROUND(M71-$O$9,1)>=-1,N71=\"NO\"),L72,NA()),NA())","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},null,null,null,null,null,null,{"$f":"IFERROR(IF(AND(ROUND(M71-$O$9,1)>=-1,N71=\"NO\"),L73,NA()),NA())","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},null,null,null,null,null,null,{"$f":"IFERROR(IF(AND(ROUND(M71-$O$9,1)>=-1,N71=\"NO\"),L74,NA()),NA())","v":{"$error":"#N/A"}}]

{"sheet":"County-Region Database","index":1,"n_rows":74,"n_cols":7,"rows_kept":74,"cut":false,"hidden":true,"merged":[]}
[]
[null,"County List","North Central Region Counties","Northeast Region Counties","Northwest Region Counties","Southeast Region Counties","Southwest Region Counties"]
[null,"Adams","Adams","Brown","Ashland","Kenosha","Columbia"]
[null,"Ashland","Florence","Calumet","Barron","Milwaukee","Crawford"]
[null,"Barron","Forest","Door","Bayfield","Ozaukee","Dane"]
[null,"Bayfield","Green Lake","Fond Du Lac","Buffalo","Racine","Dodge"]
[null,"Brown","Iron","Kewaunee","Burnett","Walworth","Grant"]
[null,"Buffalo","Langlade","Manitowoc","Chippewa","Washington","Green"]
[null,"Burnett","Lincoln","Marinette","Clark","Waukesha","Iowa"]
[null,"Calumet","Marathon","Oconto","Douglas",null,"Jefferson"]
[null,"Chippewa","Marquette","Outagamie","Dunn",null,"Juneau"]
[null,"Clark","Menominee","Sheboygan","Eau Claire",null,"La Crosse"]
[null,"Columbia","Oneida","Winnebago","Jackson",null,"Lafayette"]
[null,"Crawford","Portage",null,"Pepin",null,"Monroe"]
[null,"Dane","Price",null,"Pierce",null,"Richland"]
[null,"Dodge","Shawano",null,"Polk",null,"Rock"]
[null,"Door","Vilas",null,"Rusk",null,"Sauk"]
[null,"Douglas","Waupaca",null,"Sawyer",null,"Vernon"]
[null,"Dunn","Waushara",null,"St. Croix"]
[null,"Eau Claire","Wood",null,"Taylor"]
[null,"Florence",null,null,"Trempealeau"]
[null,"Fond Du Lac",null,null,"Washburn"]
[null,"Forest"]
[null,"Grant"]
[null,"Green"]
[null,"Green Lake"]
[null,"Iowa"]
[null,"Iron"]
[null,"Jackson"]
[null,"Jefferson"]
[null,"Juneau"]
[null,"Kenosha"]
[null,"Kewaunee"]
[null,"La Crosse"]
[null,"Lafayette"]
[null,"Langlade"]
[null,"Lincoln"]
[null,"Manitowoc"]
[null,"Marathon"]
[null,"Marinette"]
[null,"Marquette"]
[null,"Menominee"]
[null,"Milwaukee"]
[null,"Monroe"]
[null,"Oconto"]
[null,"Oneida"]
[null,"Outagamie"]
[null,"Ozaukee"]
[null,"Pepin"]
[null,"Pierce"]
[null,"Polk"]
[null,"Portage"]
[null,"Price"]
[null,"Racine"]
[null,"Richland"]
[null,"Rock"]
[null,"Rusk"]
[null,"Sauk"]
[null,"Sawyer"]
[null,"Shawano"]
[null,"Sheboygan"]
[null,"St. Croix"]
[null,"Taylor"]
[null,"Trempealeau"]
[null,"Vernon"]
[null,"Vilas"]
[null,"Walworth"]
[null,"Washburn"]
[null,"Washington"]
[null,"Waukesha"]
[null,"Waupaca"]
[null,"Waushara"]
[null,"Winnebago"]
[null,"Wood"]

{"sheet":"Worksheet Variables","index":2,"n_rows":14,"n_cols":12,"rows_kept":14,"cut":false,"hidden":true,"merged":[[13,5,13,6],[5,1,5,3],[6,1,6,2],[6,3,7,3],[10,1,10,2],[5,5,5,7],[6,5,6,6],[6,7,7,7]]}
[]
[null,"Worksheet Version:","1.0"]
[]
[null,"Pavement Density (lb./SY/in.):",112]
[]
[null,"Incentive Pay Adjustment",null,null,null,"Disincentive Pay Adjustment",null,null,null,"PWL ACCEPTANCE LIST","ALL QC & QV AIR VOIDS ACCEPTABLE LIST","DYNAMIC ALL QC & QV AIR VOIDS ACCEPTABLE LIST"]
[null,"Percent Lot Density Above Specified Minimum",null,"Pay Adjustment / Ton",null,"Percent Sublot Density Below Specified Minimum",null,"Pay Factor",null,"YES","YES",{"$f":"IF('Incentive Calculator'!$O$10='Worksheet Variables'!$J$7,\"N/A\",'Worksheet Variables'!$K$7:$K$8)","v":"YES"}]
[null,"Begin Range","End Range",null,null,"Begin Range","End Range",null,null,"NO","NO","NO"]
[null,-0.4,1,0,null,0.5,1,98]
[null,1.1000000000000001,1.8,0.4,null,1.1000000000000001,1.5,95]
[null,1.8,null,0.8,null,1.6,2,91]
[null,null,null,null,null,2.1,2.5,85]
[null,null,null,null,null,2.6,3,70]
[null,null,null,null,null,3,null,50]